--SELECT * FROM PersonTrain
--DELETE FROM PersonTrain
--INSERT INTO srv_lnk.nchr2008.dbo.PersonTrain
SELECT top 5
Convert(int,right(id,7))  AS [ID],Convert(int,right(resumeid,7))  AS [ResumeID],[StartDate] AS [BeginDate],[EndDate] AS [EndDate],[Institution]AS [SchoolName],[Location] AS [SchoolAddress],[Course] AS [SubjectName],[Qualification] AS [Certificate],[Notes] AS [OtherInfo],'Chinese' AS [strLanguage],0 AS [Flag],Convert(int,right(resumeid,7)) AS [CreatedUserId],[DateCreated] AS [CreatedDate],Convert(int,right(resumeid,7)) AS [UpdatedUserId],[LastUpdated] AS [UpdatedDate]FROM Forest.dbo.cv_training
SELECT TOP 5 * FROM Forest.dbo.cv_training
select top 5 * from srv_lnk.nchr2008.dbo.PersonTrain
